﻿USE [Accounts]
GO
/****** 对象:  Table [dbo].[accountlog]    脚本日期: 12/19/2010 14:31:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[accountlog](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[srcCardNo] [nvarchar](30) COLLATE Chinese_PRC_CI_AS NULL,
	[desCardNo] [nvarchar](30) COLLATE Chinese_PRC_CI_AS NULL,
	[amount] [float] NULL,
	[time] [datetime] NULL
) ON [PRIMARY]


USE [Accounts]
GO
/****** 对象:  Table [dbo].[accounts]    脚本日期: 12/19/2010 14:32:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[accounts](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[cardNo] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
	[userName] [nvarchar](20) COLLATE Chinese_PRC_CI_AS NULL,
	[userPassword] [nvarchar](128) COLLATE Chinese_PRC_CI_AS NULL,
	[balance] [float] NULL
) ON [PRIMARY]
